package com.ecoolex.ying.space.entity;

import com.ecoolex.framework.common.annotation.Description;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import org.springframework.lang.NonNull;

public class DesignerProjectItemsProductExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    protected Integer offset;

    protected Integer rows;

    public DesignerProjectItemsProductExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public DesignerProjectItemsProductExample orderBy(String orderByClause) {
        this.setOrderByClause(orderByClause);
        return this;
    }

    public DesignerProjectItemsProductExample orderBy(String ... orderByClauses) {
        StringBuffer sb = new StringBuffer();
        for (int i = 0; i < orderByClauses.length; i++) {
            sb.append(orderByClauses[i]);
            if (i < orderByClauses.length - 1) {
                sb.append(" , ");
            }
        }
        this.setOrderByClause(sb.toString());
        return this;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria(this);
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
        rows = null;
        offset = null;
    }

    public static Criteria newAndCreateCriteria() {
        DesignerProjectItemsProductExample example = new DesignerProjectItemsProductExample();
        return example.createCriteria();
    }

    public DesignerProjectItemsProductExample when(boolean condition, IExampleWhen then) {
        if (condition) {
            then.example(this);
        }
        return this;
    }

    public DesignerProjectItemsProductExample when(boolean condition, IExampleWhen then, IExampleWhen otherwise) {
        if (condition) {
            then.example(this);
        } else {
            otherwise.example(this);
        }
        return this;
    }

    public void setOffset(Integer offset) {
        this.offset = offset;
    }

    public Integer getOffset() {
        return this.offset;
    }

    public void setRows(Integer rows) {
        this.rows = rows;
    }

    public Integer getRows() {
        return this.rows;
    }

    public DesignerProjectItemsProductExample limit(Integer rows) {
        this.rows = rows;
        return this;
    }

    public DesignerProjectItemsProductExample limit(Integer offset, Integer rows) {
        this.offset = offset;
        this.rows = rows;
        return this;
    }

    public DesignerProjectItemsProductExample page(Integer page, Integer pageSize) {
        this.offset = page * pageSize;
        this.rows = pageSize;
        return this;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andItemsProductIdIsNull() {
            addCriterion("designerprojectitemsproduct.ItemsProductId is null");
            return (Criteria) this;
        }

        public Criteria andItemsProductIdIsNotNull() {
            addCriterion("designerprojectitemsproduct.ItemsProductId is not null");
            return (Criteria) this;
        }

        public Criteria andItemsProductIdEqualTo(Integer value) {
            addCriterion("designerprojectitemsproduct.ItemsProductId =", value, "itemsProductId");
            return (Criteria) this;
        }

        public Criteria andItemsProductIdEqualToColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.ItemsProductId = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andItemsProductIdNotEqualTo(Integer value) {
            addCriterion("designerprojectitemsproduct.ItemsProductId <>", value, "itemsProductId");
            return (Criteria) this;
        }

        public Criteria andItemsProductIdNotEqualToColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.ItemsProductId <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andItemsProductIdGreaterThan(Integer value) {
            addCriterion("designerprojectitemsproduct.ItemsProductId >", value, "itemsProductId");
            return (Criteria) this;
        }

        public Criteria andItemsProductIdGreaterThanColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.ItemsProductId > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andItemsProductIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("designerprojectitemsproduct.ItemsProductId >=", value, "itemsProductId");
            return (Criteria) this;
        }

        public Criteria andItemsProductIdGreaterThanOrEqualToColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.ItemsProductId >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andItemsProductIdLessThan(Integer value) {
            addCriterion("designerprojectitemsproduct.ItemsProductId <", value, "itemsProductId");
            return (Criteria) this;
        }

        public Criteria andItemsProductIdLessThanColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.ItemsProductId < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andItemsProductIdLessThanOrEqualTo(Integer value) {
            addCriterion("designerprojectitemsproduct.ItemsProductId <=", value, "itemsProductId");
            return (Criteria) this;
        }

        public Criteria andItemsProductIdLessThanOrEqualToColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.ItemsProductId <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andItemsProductIdIn(List<Integer> values) {
            addCriterion("designerprojectitemsproduct.ItemsProductId in", values, "itemsProductId");
            return (Criteria) this;
        }

        public Criteria andItemsProductIdNotIn(List<Integer> values) {
            addCriterion("designerprojectitemsproduct.ItemsProductId not in", values, "itemsProductId");
            return (Criteria) this;
        }

        public Criteria andItemsProductIdBetween(Integer value1, Integer value2) {
            addCriterion("designerprojectitemsproduct.ItemsProductId between", value1, value2, "itemsProductId");
            return (Criteria) this;
        }

        public Criteria andItemsProductIdNotBetween(Integer value1, Integer value2) {
            addCriterion("designerprojectitemsproduct.ItemsProductId not between", value1, value2, "itemsProductId");
            return (Criteria) this;
        }

        public Criteria andUserIdIsNull() {
            addCriterion("designerprojectitemsproduct.UserId is null");
            return (Criteria) this;
        }

        public Criteria andUserIdIsNotNull() {
            addCriterion("designerprojectitemsproduct.UserId is not null");
            return (Criteria) this;
        }

        public Criteria andUserIdEqualTo(Integer value) {
            addCriterion("designerprojectitemsproduct.UserId =", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdEqualToColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.UserId = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUserIdNotEqualTo(Integer value) {
            addCriterion("designerprojectitemsproduct.UserId <>", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotEqualToColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.UserId <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUserIdGreaterThan(Integer value) {
            addCriterion("designerprojectitemsproduct.UserId >", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdGreaterThanColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.UserId > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUserIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("designerprojectitemsproduct.UserId >=", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdGreaterThanOrEqualToColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.UserId >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUserIdLessThan(Integer value) {
            addCriterion("designerprojectitemsproduct.UserId <", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdLessThanColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.UserId < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUserIdLessThanOrEqualTo(Integer value) {
            addCriterion("designerprojectitemsproduct.UserId <=", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdLessThanOrEqualToColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.UserId <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUserIdIn(List<Integer> values) {
            addCriterion("designerprojectitemsproduct.UserId in", values, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotIn(List<Integer> values) {
            addCriterion("designerprojectitemsproduct.UserId not in", values, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdBetween(Integer value1, Integer value2) {
            addCriterion("designerprojectitemsproduct.UserId between", value1, value2, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotBetween(Integer value1, Integer value2) {
            addCriterion("designerprojectitemsproduct.UserId not between", value1, value2, "userId");
            return (Criteria) this;
        }

        public Criteria andProjectIdIsNull() {
            addCriterion("designerprojectitemsproduct.ProjectId is null");
            return (Criteria) this;
        }

        public Criteria andProjectIdIsNotNull() {
            addCriterion("designerprojectitemsproduct.ProjectId is not null");
            return (Criteria) this;
        }

        public Criteria andProjectIdEqualTo(Integer value) {
            addCriterion("designerprojectitemsproduct.ProjectId =", value, "projectId");
            return (Criteria) this;
        }

        public Criteria andProjectIdEqualToColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.ProjectId = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProjectIdNotEqualTo(Integer value) {
            addCriterion("designerprojectitemsproduct.ProjectId <>", value, "projectId");
            return (Criteria) this;
        }

        public Criteria andProjectIdNotEqualToColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.ProjectId <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProjectIdGreaterThan(Integer value) {
            addCriterion("designerprojectitemsproduct.ProjectId >", value, "projectId");
            return (Criteria) this;
        }

        public Criteria andProjectIdGreaterThanColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.ProjectId > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProjectIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("designerprojectitemsproduct.ProjectId >=", value, "projectId");
            return (Criteria) this;
        }

        public Criteria andProjectIdGreaterThanOrEqualToColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.ProjectId >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProjectIdLessThan(Integer value) {
            addCriterion("designerprojectitemsproduct.ProjectId <", value, "projectId");
            return (Criteria) this;
        }

        public Criteria andProjectIdLessThanColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.ProjectId < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProjectIdLessThanOrEqualTo(Integer value) {
            addCriterion("designerprojectitemsproduct.ProjectId <=", value, "projectId");
            return (Criteria) this;
        }

        public Criteria andProjectIdLessThanOrEqualToColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.ProjectId <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andProjectIdIn(List<Integer> values) {
            addCriterion("designerprojectitemsproduct.ProjectId in", values, "projectId");
            return (Criteria) this;
        }

        public Criteria andProjectIdNotIn(List<Integer> values) {
            addCriterion("designerprojectitemsproduct.ProjectId not in", values, "projectId");
            return (Criteria) this;
        }

        public Criteria andProjectIdBetween(Integer value1, Integer value2) {
            addCriterion("designerprojectitemsproduct.ProjectId between", value1, value2, "projectId");
            return (Criteria) this;
        }

        public Criteria andProjectIdNotBetween(Integer value1, Integer value2) {
            addCriterion("designerprojectitemsproduct.ProjectId not between", value1, value2, "projectId");
            return (Criteria) this;
        }

        public Criteria andItemsIdIsNull() {
            addCriterion("designerprojectitemsproduct.ItemsId is null");
            return (Criteria) this;
        }

        public Criteria andItemsIdIsNotNull() {
            addCriterion("designerprojectitemsproduct.ItemsId is not null");
            return (Criteria) this;
        }

        public Criteria andItemsIdEqualTo(Integer value) {
            addCriterion("designerprojectitemsproduct.ItemsId =", value, "itemsId");
            return (Criteria) this;
        }

        public Criteria andItemsIdEqualToColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.ItemsId = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andItemsIdNotEqualTo(Integer value) {
            addCriterion("designerprojectitemsproduct.ItemsId <>", value, "itemsId");
            return (Criteria) this;
        }

        public Criteria andItemsIdNotEqualToColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.ItemsId <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andItemsIdGreaterThan(Integer value) {
            addCriterion("designerprojectitemsproduct.ItemsId >", value, "itemsId");
            return (Criteria) this;
        }

        public Criteria andItemsIdGreaterThanColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.ItemsId > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andItemsIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("designerprojectitemsproduct.ItemsId >=", value, "itemsId");
            return (Criteria) this;
        }

        public Criteria andItemsIdGreaterThanOrEqualToColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.ItemsId >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andItemsIdLessThan(Integer value) {
            addCriterion("designerprojectitemsproduct.ItemsId <", value, "itemsId");
            return (Criteria) this;
        }

        public Criteria andItemsIdLessThanColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.ItemsId < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andItemsIdLessThanOrEqualTo(Integer value) {
            addCriterion("designerprojectitemsproduct.ItemsId <=", value, "itemsId");
            return (Criteria) this;
        }

        public Criteria andItemsIdLessThanOrEqualToColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.ItemsId <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andItemsIdIn(List<Integer> values) {
            addCriterion("designerprojectitemsproduct.ItemsId in", values, "itemsId");
            return (Criteria) this;
        }

        public Criteria andItemsIdNotIn(List<Integer> values) {
            addCriterion("designerprojectitemsproduct.ItemsId not in", values, "itemsId");
            return (Criteria) this;
        }

        public Criteria andItemsIdBetween(Integer value1, Integer value2) {
            addCriterion("designerprojectitemsproduct.ItemsId between", value1, value2, "itemsId");
            return (Criteria) this;
        }

        public Criteria andItemsIdNotBetween(Integer value1, Integer value2) {
            addCriterion("designerprojectitemsproduct.ItemsId not between", value1, value2, "itemsId");
            return (Criteria) this;
        }

        public Criteria andPickGoodsIdIsNull() {
            addCriterion("designerprojectitemsproduct.PickGoodsId is null");
            return (Criteria) this;
        }

        public Criteria andPickGoodsIdIsNotNull() {
            addCriterion("designerprojectitemsproduct.PickGoodsId is not null");
            return (Criteria) this;
        }

        public Criteria andPickGoodsIdEqualTo(Integer value) {
            addCriterion("designerprojectitemsproduct.PickGoodsId =", value, "pickGoodsId");
            return (Criteria) this;
        }

        public Criteria andPickGoodsIdEqualToColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.PickGoodsId = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPickGoodsIdNotEqualTo(Integer value) {
            addCriterion("designerprojectitemsproduct.PickGoodsId <>", value, "pickGoodsId");
            return (Criteria) this;
        }

        public Criteria andPickGoodsIdNotEqualToColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.PickGoodsId <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPickGoodsIdGreaterThan(Integer value) {
            addCriterion("designerprojectitemsproduct.PickGoodsId >", value, "pickGoodsId");
            return (Criteria) this;
        }

        public Criteria andPickGoodsIdGreaterThanColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.PickGoodsId > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPickGoodsIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("designerprojectitemsproduct.PickGoodsId >=", value, "pickGoodsId");
            return (Criteria) this;
        }

        public Criteria andPickGoodsIdGreaterThanOrEqualToColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.PickGoodsId >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPickGoodsIdLessThan(Integer value) {
            addCriterion("designerprojectitemsproduct.PickGoodsId <", value, "pickGoodsId");
            return (Criteria) this;
        }

        public Criteria andPickGoodsIdLessThanColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.PickGoodsId < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPickGoodsIdLessThanOrEqualTo(Integer value) {
            addCriterion("designerprojectitemsproduct.PickGoodsId <=", value, "pickGoodsId");
            return (Criteria) this;
        }

        public Criteria andPickGoodsIdLessThanOrEqualToColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.PickGoodsId <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPickGoodsIdIn(List<Integer> values) {
            addCriterion("designerprojectitemsproduct.PickGoodsId in", values, "pickGoodsId");
            return (Criteria) this;
        }

        public Criteria andPickGoodsIdNotIn(List<Integer> values) {
            addCriterion("designerprojectitemsproduct.PickGoodsId not in", values, "pickGoodsId");
            return (Criteria) this;
        }

        public Criteria andPickGoodsIdBetween(Integer value1, Integer value2) {
            addCriterion("designerprojectitemsproduct.PickGoodsId between", value1, value2, "pickGoodsId");
            return (Criteria) this;
        }

        public Criteria andPickGoodsIdNotBetween(Integer value1, Integer value2) {
            addCriterion("designerprojectitemsproduct.PickGoodsId not between", value1, value2, "pickGoodsId");
            return (Criteria) this;
        }

        public Criteria andPickProductIdIsNull() {
            addCriterion("designerprojectitemsproduct.PickProductId is null");
            return (Criteria) this;
        }

        public Criteria andPickProductIdIsNotNull() {
            addCriterion("designerprojectitemsproduct.PickProductId is not null");
            return (Criteria) this;
        }

        public Criteria andPickProductIdEqualTo(Integer value) {
            addCriterion("designerprojectitemsproduct.PickProductId =", value, "pickProductId");
            return (Criteria) this;
        }

        public Criteria andPickProductIdEqualToColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.PickProductId = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPickProductIdNotEqualTo(Integer value) {
            addCriterion("designerprojectitemsproduct.PickProductId <>", value, "pickProductId");
            return (Criteria) this;
        }

        public Criteria andPickProductIdNotEqualToColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.PickProductId <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPickProductIdGreaterThan(Integer value) {
            addCriterion("designerprojectitemsproduct.PickProductId >", value, "pickProductId");
            return (Criteria) this;
        }

        public Criteria andPickProductIdGreaterThanColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.PickProductId > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPickProductIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("designerprojectitemsproduct.PickProductId >=", value, "pickProductId");
            return (Criteria) this;
        }

        public Criteria andPickProductIdGreaterThanOrEqualToColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.PickProductId >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPickProductIdLessThan(Integer value) {
            addCriterion("designerprojectitemsproduct.PickProductId <", value, "pickProductId");
            return (Criteria) this;
        }

        public Criteria andPickProductIdLessThanColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.PickProductId < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPickProductIdLessThanOrEqualTo(Integer value) {
            addCriterion("designerprojectitemsproduct.PickProductId <=", value, "pickProductId");
            return (Criteria) this;
        }

        public Criteria andPickProductIdLessThanOrEqualToColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.PickProductId <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPickProductIdIn(List<Integer> values) {
            addCriterion("designerprojectitemsproduct.PickProductId in", values, "pickProductId");
            return (Criteria) this;
        }

        public Criteria andPickProductIdNotIn(List<Integer> values) {
            addCriterion("designerprojectitemsproduct.PickProductId not in", values, "pickProductId");
            return (Criteria) this;
        }

        public Criteria andPickProductIdBetween(Integer value1, Integer value2) {
            addCriterion("designerprojectitemsproduct.PickProductId between", value1, value2, "pickProductId");
            return (Criteria) this;
        }

        public Criteria andPickProductIdNotBetween(Integer value1, Integer value2) {
            addCriterion("designerprojectitemsproduct.PickProductId not between", value1, value2, "pickProductId");
            return (Criteria) this;
        }

        public Criteria andNumberIsNull() {
            addCriterion("designerprojectitemsproduct.`Number` is null");
            return (Criteria) this;
        }

        public Criteria andNumberIsNotNull() {
            addCriterion("designerprojectitemsproduct.`Number` is not null");
            return (Criteria) this;
        }

        public Criteria andNumberEqualTo(Integer value) {
            addCriterion("designerprojectitemsproduct.`Number` =", value, "number");
            return (Criteria) this;
        }

        public Criteria andNumberEqualToColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.`Number` = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNumberNotEqualTo(Integer value) {
            addCriterion("designerprojectitemsproduct.`Number` <>", value, "number");
            return (Criteria) this;
        }

        public Criteria andNumberNotEqualToColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.`Number` <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNumberGreaterThan(Integer value) {
            addCriterion("designerprojectitemsproduct.`Number` >", value, "number");
            return (Criteria) this;
        }

        public Criteria andNumberGreaterThanColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.`Number` > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNumberGreaterThanOrEqualTo(Integer value) {
            addCriterion("designerprojectitemsproduct.`Number` >=", value, "number");
            return (Criteria) this;
        }

        public Criteria andNumberGreaterThanOrEqualToColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.`Number` >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNumberLessThan(Integer value) {
            addCriterion("designerprojectitemsproduct.`Number` <", value, "number");
            return (Criteria) this;
        }

        public Criteria andNumberLessThanColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.`Number` < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNumberLessThanOrEqualTo(Integer value) {
            addCriterion("designerprojectitemsproduct.`Number` <=", value, "number");
            return (Criteria) this;
        }

        public Criteria andNumberLessThanOrEqualToColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.`Number` <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNumberIn(List<Integer> values) {
            addCriterion("designerprojectitemsproduct.`Number` in", values, "number");
            return (Criteria) this;
        }

        public Criteria andNumberNotIn(List<Integer> values) {
            addCriterion("designerprojectitemsproduct.`Number` not in", values, "number");
            return (Criteria) this;
        }

        public Criteria andNumberBetween(Integer value1, Integer value2) {
            addCriterion("designerprojectitemsproduct.`Number` between", value1, value2, "number");
            return (Criteria) this;
        }

        public Criteria andNumberNotBetween(Integer value1, Integer value2) {
            addCriterion("designerprojectitemsproduct.`Number` not between", value1, value2, "number");
            return (Criteria) this;
        }

        public Criteria andSortingIsNull() {
            addCriterion("designerprojectitemsproduct.Sorting is null");
            return (Criteria) this;
        }

        public Criteria andSortingIsNotNull() {
            addCriterion("designerprojectitemsproduct.Sorting is not null");
            return (Criteria) this;
        }

        public Criteria andSortingEqualTo(Integer value) {
            addCriterion("designerprojectitemsproduct.Sorting =", value, "sorting");
            return (Criteria) this;
        }

        public Criteria andSortingEqualToColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.Sorting = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSortingNotEqualTo(Integer value) {
            addCriterion("designerprojectitemsproduct.Sorting <>", value, "sorting");
            return (Criteria) this;
        }

        public Criteria andSortingNotEqualToColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.Sorting <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSortingGreaterThan(Integer value) {
            addCriterion("designerprojectitemsproduct.Sorting >", value, "sorting");
            return (Criteria) this;
        }

        public Criteria andSortingGreaterThanColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.Sorting > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSortingGreaterThanOrEqualTo(Integer value) {
            addCriterion("designerprojectitemsproduct.Sorting >=", value, "sorting");
            return (Criteria) this;
        }

        public Criteria andSortingGreaterThanOrEqualToColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.Sorting >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSortingLessThan(Integer value) {
            addCriterion("designerprojectitemsproduct.Sorting <", value, "sorting");
            return (Criteria) this;
        }

        public Criteria andSortingLessThanColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.Sorting < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSortingLessThanOrEqualTo(Integer value) {
            addCriterion("designerprojectitemsproduct.Sorting <=", value, "sorting");
            return (Criteria) this;
        }

        public Criteria andSortingLessThanOrEqualToColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.Sorting <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSortingIn(List<Integer> values) {
            addCriterion("designerprojectitemsproduct.Sorting in", values, "sorting");
            return (Criteria) this;
        }

        public Criteria andSortingNotIn(List<Integer> values) {
            addCriterion("designerprojectitemsproduct.Sorting not in", values, "sorting");
            return (Criteria) this;
        }

        public Criteria andSortingBetween(Integer value1, Integer value2) {
            addCriterion("designerprojectitemsproduct.Sorting between", value1, value2, "sorting");
            return (Criteria) this;
        }

        public Criteria andSortingNotBetween(Integer value1, Integer value2) {
            addCriterion("designerprojectitemsproduct.Sorting not between", value1, value2, "sorting");
            return (Criteria) this;
        }

        public Criteria andDeletedIsNull() {
            addCriterion("designerprojectitemsproduct.Deleted is null");
            return (Criteria) this;
        }

        public Criteria andDeletedIsNotNull() {
            addCriterion("designerprojectitemsproduct.Deleted is not null");
            return (Criteria) this;
        }

        public Criteria andDeletedEqualTo(Boolean value) {
            addCriterion("designerprojectitemsproduct.Deleted =", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedEqualToColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.Deleted = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedNotEqualTo(Boolean value) {
            addCriterion("designerprojectitemsproduct.Deleted <>", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotEqualToColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.Deleted <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThan(Boolean value) {
            addCriterion("designerprojectitemsproduct.Deleted >", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.Deleted > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanOrEqualTo(Boolean value) {
            addCriterion("designerprojectitemsproduct.Deleted >=", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanOrEqualToColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.Deleted >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedLessThan(Boolean value) {
            addCriterion("designerprojectitemsproduct.Deleted <", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.Deleted < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanOrEqualTo(Boolean value) {
            addCriterion("designerprojectitemsproduct.Deleted <=", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanOrEqualToColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.Deleted <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedIn(List<Boolean> values) {
            addCriterion("designerprojectitemsproduct.Deleted in", values, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotIn(List<Boolean> values) {
            addCriterion("designerprojectitemsproduct.Deleted not in", values, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedBetween(Boolean value1, Boolean value2) {
            addCriterion("designerprojectitemsproduct.Deleted between", value1, value2, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotBetween(Boolean value1, Boolean value2) {
            addCriterion("designerprojectitemsproduct.Deleted not between", value1, value2, "deleted");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNull() {
            addCriterion("designerprojectitemsproduct.`CreateUser` is null");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNotNull() {
            addCriterion("designerprojectitemsproduct.`CreateUser` is not null");
            return (Criteria) this;
        }

        public Criteria andCreateUserEqualTo(String value) {
            addCriterion("designerprojectitemsproduct.`CreateUser` =", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserEqualToColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.`CreateUser` = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserNotEqualTo(String value) {
            addCriterion("designerprojectitemsproduct.`CreateUser` <>", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotEqualToColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.`CreateUser` <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThan(String value) {
            addCriterion("designerprojectitemsproduct.`CreateUser` >", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.`CreateUser` > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanOrEqualTo(String value) {
            addCriterion("designerprojectitemsproduct.`CreateUser` >=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanOrEqualToColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.`CreateUser` >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThan(String value) {
            addCriterion("designerprojectitemsproduct.`CreateUser` <", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.`CreateUser` < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanOrEqualTo(String value) {
            addCriterion("designerprojectitemsproduct.`CreateUser` <=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanOrEqualToColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.`CreateUser` <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserLike(String value) {
            addCriterion("designerprojectitemsproduct.`CreateUser` like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotLike(String value) {
            addCriterion("designerprojectitemsproduct.`CreateUser` not like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserIn(List<String> values) {
            addCriterion("designerprojectitemsproduct.`CreateUser` in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotIn(List<String> values) {
            addCriterion("designerprojectitemsproduct.`CreateUser` not in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserBetween(String value1, String value2) {
            addCriterion("designerprojectitemsproduct.`CreateUser` between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotBetween(String value1, String value2) {
            addCriterion("designerprojectitemsproduct.`CreateUser` not between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("designerprojectitemsproduct.CreateTime is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("designerprojectitemsproduct.CreateTime is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(Date value) {
            addCriterion("designerprojectitemsproduct.CreateTime =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualToColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.CreateTime = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(Date value) {
            addCriterion("designerprojectitemsproduct.CreateTime <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualToColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.CreateTime <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(Date value) {
            addCriterion("designerprojectitemsproduct.CreateTime >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.CreateTime > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("designerprojectitemsproduct.CreateTime >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualToColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.CreateTime >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(Date value) {
            addCriterion("designerprojectitemsproduct.CreateTime <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.CreateTime < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("designerprojectitemsproduct.CreateTime <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualToColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.CreateTime <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<Date> values) {
            addCriterion("designerprojectitemsproduct.CreateTime in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<Date> values) {
            addCriterion("designerprojectitemsproduct.CreateTime not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(Date value1, Date value2) {
            addCriterion("designerprojectitemsproduct.CreateTime between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("designerprojectitemsproduct.CreateTime not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIsNull() {
            addCriterion("designerprojectitemsproduct.UpdateUser is null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIsNotNull() {
            addCriterion("designerprojectitemsproduct.UpdateUser is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserEqualTo(String value) {
            addCriterion("designerprojectitemsproduct.UpdateUser =", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserEqualToColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.UpdateUser = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotEqualTo(String value) {
            addCriterion("designerprojectitemsproduct.UpdateUser <>", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotEqualToColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.UpdateUser <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThan(String value) {
            addCriterion("designerprojectitemsproduct.UpdateUser >", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.UpdateUser > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanOrEqualTo(String value) {
            addCriterion("designerprojectitemsproduct.UpdateUser >=", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanOrEqualToColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.UpdateUser >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThan(String value) {
            addCriterion("designerprojectitemsproduct.UpdateUser <", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.UpdateUser < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanOrEqualTo(String value) {
            addCriterion("designerprojectitemsproduct.UpdateUser <=", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanOrEqualToColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.UpdateUser <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserLike(String value) {
            addCriterion("designerprojectitemsproduct.UpdateUser like", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotLike(String value) {
            addCriterion("designerprojectitemsproduct.UpdateUser not like", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIn(List<String> values) {
            addCriterion("designerprojectitemsproduct.UpdateUser in", values, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotIn(List<String> values) {
            addCriterion("designerprojectitemsproduct.UpdateUser not in", values, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserBetween(String value1, String value2) {
            addCriterion("designerprojectitemsproduct.UpdateUser between", value1, value2, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotBetween(String value1, String value2) {
            addCriterion("designerprojectitemsproduct.UpdateUser not between", value1, value2, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNull() {
            addCriterion("designerprojectitemsproduct.UpdateTime is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNotNull() {
            addCriterion("designerprojectitemsproduct.UpdateTime is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualTo(Date value) {
            addCriterion("designerprojectitemsproduct.UpdateTime =", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualToColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.UpdateTime = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualTo(Date value) {
            addCriterion("designerprojectitemsproduct.UpdateTime <>", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualToColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.UpdateTime <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThan(Date value) {
            addCriterion("designerprojectitemsproduct.UpdateTime >", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.UpdateTime > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("designerprojectitemsproduct.UpdateTime >=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualToColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.UpdateTime >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThan(Date value) {
            addCriterion("designerprojectitemsproduct.UpdateTime <", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.UpdateTime < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("designerprojectitemsproduct.UpdateTime <=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualToColumn(DesignerProjectItemsProduct.Column column) {
            addCriterion(new StringBuilder("designerprojectitemsproduct.UpdateTime <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIn(List<Date> values) {
            addCriterion("designerprojectitemsproduct.UpdateTime in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotIn(List<Date> values) {
            addCriterion("designerprojectitemsproduct.UpdateTime not in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("designerprojectitemsproduct.UpdateTime between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("designerprojectitemsproduct.UpdateTime not between", value1, value2, "updateTime");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {
        private DesignerProjectItemsProductExample example;

        protected Criteria(DesignerProjectItemsProductExample example) {
            super();
            this.example = example;
        }

        public DesignerProjectItemsProductExample example() {
            return this.example;
        }

        @Deprecated
        public Criteria andIf(boolean ifAdd, ICriteriaAdd add) {
            if (ifAdd) {
                add.add(this);
            }
            return this;
        }

        public Criteria when(boolean condition, ICriteriaWhen then) {
            if (condition) {
                then.criteria(this);
            }
            return this;
        }

        public Criteria when(boolean condition, ICriteriaWhen then, ICriteriaWhen otherwise) {
            if (condition) {
                then.criteria(this);
            } else {
                otherwise.criteria(this);
            }
            return this;
        }

        public Criteria andLogicalDeleted(boolean deleted) {
            return deleted ? andDeletedEqualTo(DesignerProjectItemsProduct.Deleted.IS_DELETED.value()) : andDeletedNotEqualTo(DesignerProjectItemsProduct.Deleted.IS_DELETED.value());
        }

        @Deprecated
        public interface ICriteriaAdd {
            Criteria add(Criteria add);
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }

    public interface ICriteriaWhen {
        void criteria(Criteria criteria);
    }

    public interface IExampleWhen {
        void example(com.ecoolex.ying.space.entity.DesignerProjectItemsProductExample example);
    }
}